USE [DBExpertGerencial]
GO

/****** Object:  Table [dbo].[Vendedores]    Script Date: 02/08/2014 16:51:49 ******/
DROP TABLE [dbo].[Vendedores]
GO

/****** Object:  Table [dbo].[Vendedores]    Script Date: 02/08/2014 16:51:49 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Vendedores](
	[CodVendedor] [int]  identity (1,1)NOT NULL,
	[NomeVendedor] [nvarchar](50) NOT NULL,
	[CPF] [nvarchar](14),
	[Telefone1] [nvarchar](16) NOT NULL,
	[Telefone2] [nvarchar](16) ,
	[Email] [nvarchar](50) NOT NULL,
	[FazPedidoClienteBloqueadoSN] [bit] ,
	[DataAdmissao] [datetime] ,
	[Comissao] [decimal](10, 2) NULL,
 CONSTRAINT [PK_Cod_Vendedor] PRIMARY KEY (CodVendedor) 
)




